{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input Sheet","Real Estate Financing Calc.","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Sheet","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[18,2,18,7],[11,2,11,6]]}
["Data Input Sheet "]
[]
["Purchase Price",1777000]
["Down Payment",0]
["Amount of Purchase Price Financed",{"$f":"B3-B4","v":1777000}]
["Guaranteed Interest Rate",5.8999999999999997E-2]
["Guaranteed  Terms",30]
["Bank Beg. Farmer/SDA Down Payment Terms",30]
["FSA Beg. Farmer/SDA Down Payment Terms",20]
["FSA  D-FO Interest Rate",0.04]
["FSA D-FO Terms",25]
["Particpation Lender Portion Amount",1176000,{"$f":"IF(AND(B5>0,B12=0),\"Warning! Must Enter Value\",IF(AND(B5>600000,B12<B5-600000),\"Warning FSA loan Amount Exceeded\",IF(B12>B5,\"Warning! Value Exceeds Amount Financed\",\"\")))","v":"Warning FSA loan Amount Exceeded"}]
["Land Price/Acre ",8000]
[]
[]
["Shared Lien Postion RFA/Unguaranteed Portion",577000]
["Shared Lien Postion Guaranteed Amount",600000,{"$f":"IF(AND(B18=600000,B17>1150000),\"Warning! FSA Loan Amount Exceeded\",  IF(B17+B18>1750000,\"Warning! FSA Loan Amount Exceeded\",\"\"))","v":""}]
["Shared Lien Position FSA Amount",600000,{"$f":"IF(B18>600000,\"Warning! FSA Loan Amount Exceeded\",\"\")","v":""}]
[null,{"$f":"SUM(B16:B18)","v":1777000},{"$f":"IF(OR(B16+B17+B18>B5, B16+B17+B18<B5),\"Warning! Total Does Not Match Amount Financed\",\"\")","v":""}]
["Shared Lien Postion RFA/Unguaranteed Interest Rate",0]
["Shared Lien Postion RFA/Unguaranteed Terms",0]
[]
[]
["Note:  When a unguaranteed real estate loan and guaranteed real estate loan share the same"]
["lien position the 85% loan to value ratio does not apply to junior liens for guaranteed real estate loans."]
[]
["All three Shared Position amounts must equal Amount of Purchase Price Financed."]
[]
["The Shared Lien Option can be used to calculate payment if Rural Finance Authority Loan programs are being used."]
["The Rural Finance portion may be guaranteed or unguaranteed depending Rural Fianace Authority Loan program and subject to FSA loan limits."]
[]
["Failure to correct any displaying \"Warning Messages\" will result in the option being blacked out."]
[]
["Disclaimer:  This calculator is only a guide.  Accuracy of the results are not guaranteed and are subject to the rules and regulations of the Farm Service Agency"]
["Version 6.5 last updated 11/8/19"]

{"sheet":"Real Estate Financing Calc.","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[34,9,35,10],[36,9,37,10],[38,9,39,10],[24,9,25,10],[26,9,27,10],[28,9,29,10],[30,9,31,10],[40,9,41,10],[21,9,21,10],[22,9,22,10],[4,9,4,10],[0,9,3,10],[5,9,5,10],[6,9,6,10],[14,9,14,10],[15,9,15,10],[32,9,33,10],[9,7,12,8],[12,9,12,10],[7,9,7,10],[8,9,8,10],[10,9,10,10],[11,9,11,10],[30,7,31,8],[32,7,33,8],[9,0,12,0],[9,1,12,1],[17,1,20,1],[14,2,14,3],[17,0,20,0],[15,2,15,3],[16,2,16,3],[18,2,18,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[16,5,16,6],[22,5,22,6],[16,9,16,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,0,22,0],[19,2,19,3],[20,2,20,3],[22,2,22,3],[13,0,16,0],[30,1,31,1],[32,1,33,1],[34,1,35,1],[36,1,37,1],[38,1,39,1],[40,1,41,1],[34,4,35,4],[36,4,37,4],[38,2,39,3],[40,2,41,3],[30,2,31,3],[32,2,33,3],[34,2,35,3],[36,2,37,3],[38,4,39,4],[40,4,41,4],[30,4,31,4],[32,4,33,4],[34,7,35,8],[36,7,37,8],[38,7,39,8],[40,7,41,8],[38,5,39,6],[40,5,41,6],[34,5,35,6],[5,5,5,6],[7,5,7,6],[26,7,27,8],[28,7,29,8],[16,7,16,8],[24,7,25,8],[20,7,20,8],[14,7,14,8],[15,7,15,8],[28,5,29,6],[30,5,31,6],[32,5,33,6],[36,5,37,6],[15,5,15,6],[9,5,12,6],[19,5,19,6],[20,5,20,6],[26,1,27,1],[28,1,29,1],[26,2,27,3],[28,2,29,3],[26,5,27,6],[24,5,25,6],[24,1,25,1],[24,2,25,3],[24,4,25,4],[26,4,27,4],[28,4,29,4],[0,4,3,4],[0,5,3,6],[0,2,3,3],[23,0,23,10],[6,7,6,8],[5,7,5,8],[7,7,7,8],[22,7,22,8],[18,7,18,8],[19,7,19,8],[0,7,3,8],[4,7,4,8],[0,0,2,0],[4,2,4,3],[5,2,5,3],[6,2,6,3],[0,1,3,1],[7,2,7,3],[4,5,4,6],[14,5,14,6],[6,5,6,6],[13,4,16,4],[9,4,12,4],[18,5,18,6]]}
[null,"GUARANTEE FARM OWNERSHIP LOANS ","BEG. FARMER/   SDA DOWN PAYMENT",null,"DIRECT FARM OWNERSHIP ","50/50       JOINT FINANCING ",null,"PARTICPATION FINANCING",null,"SHARED LIEN BANK/GUAR/DIRECT"]
[]
[]
["PURCHASE PRICE"]
[{"$f":"'Input Sheet'!B3","v":1777000},{"$f":"'Input Sheet'!B3","v":1777000},{"$f":"'Input Sheet'!B3","v":1777000},null,{"$f":"'Input Sheet'!B3","v":1777000},{"$f":"'Input Sheet'!B3","v":1777000},null,{"$f":"'Input Sheet'!B3","v":1777000},null,{"$f":"'Input Sheet'!B3","v":1777000}]
["DOWN PAYMENT",{"$f":"B7/B5","v":0},{"$f":"C7/C5","v":0.05},null,{"$f":"E7/E5","v":0},{"$f":"F7/F5","v":0},null,{"$f":"H7/H5","v":0},null,{"$f":"J7/J5","v":0}]
[{"$f":"'Input Sheet'!B4","v":0},{"$f":"A7","v":0},{"$f":"IF(A7>A5*0.05,A7,A5*0.05)","v":88850},null,{"$f":"A7","v":0},{"$f":"A7","v":0},null,{"$f":"'Input Sheet'!B4","v":0},null,{"$f":"A7","v":0}]
["AMOUNT OF PURCHASE PRICE FINANCED",{"$f":"'Input Sheet'!B5","v":1777000},{"$f":"C5-C7","v":1688150},null,{"$f":"'Input Sheet'!B5","v":1777000},{"$f":"'Input Sheet'!B5","v":1777000},null,{"$f":"H5-H7","v":1777000},null,{"$f":"J5-J7","v":1777000}]
["TERMS"]
["BANK             LOAN AMOUNT   YEARS    INTEREST RATE","N/A","Bank",{"$f":"C11/C5","v":0},"N/A","See Note",null,"See Note",null,"Bank",{"$f":"J11/J8","v":0.32470455824423183}]
[null,null,{"$f":"IF(C8>1750000,C8-1750000,0)","v":0},null,null,null,null,null,null,{"$f":"'Input Sheet'!B16","v":577000}]
[null,null,{"$f":"'Input Sheet'!B8","v":30},null,null,null,null,null,null,{"$f":"IF('Input Sheet'!B21=0,J16,'Input Sheet'!B21)","v":30}]
[null,null,{"$f":"'Input Sheet'!B20","v":0},null,null,null,null,null,null,{"$f":"IF('Input Sheet'!B20 = 0,J17,'Input Sheet'!B20)","v":5.8999999999999997E-2}]
["BANK  GUAR.            LOAN AMOUNT   YEARS    INTEREST RATE","Bank (100%)","Bank",{"$f":"C15/C5","v":0.78109172763083845},"N/A","Bank",{"$f":"F15/F8","v":0.5},"Bank",{"$f":"H15/H8","v":0.66178953292065279},"Bank",{"$f":"J15/J8","v":0.33764772087788408}]
[null,{"$f":"B8","v":1777000},{"$f":"IF(AND(C5>667000,C5>1869473,C8>1776000),1475850,IF(AND(C5>667000,C5<=1837500),C8-300150,IF(AND(C5>1837500,C8<=1776000),C8-300150,IF(AND(C5<=667000, C7=C5*0.05), C5*0.5,IF(AND(C5<=667000,C7>C5*0.05),C5-(C5*0.45)-C7)))))","v":1388000},null,null,{"$f":"F8/2","v":888500},null,{"$f":"'Input Sheet'!B12","v":1176000},null,{"$f":"'Input Sheet'!B17","v":600000}]
[null,{"$f":"'Input Sheet'!B7","v":30},{"$f":"'Input Sheet'!B8","v":30},null,null,{"$f":"B16","v":30},null,{"$f":"B16","v":30},null,{"$f":"H16","v":30}]
[null,{"$f":"'Input Sheet'!B6","v":5.8999999999999997E-2},{"$f":"B17","v":5.8999999999999997E-2},null,null,{"$f":"B17","v":5.8999999999999997E-2},null,{"$f":"B17","v":5.8999999999999997E-2},null,{"$f":"B17","v":5.8999999999999997E-2}]
["FSA                 LOAN AMOUNT   YEARS      INTEREST RATE","N/A"," FSA",{"$f":"C19/C5","v":0.16890827236916151},"FSA (100%)","FSA",{"$f":"F19/F8","v":0.5},"FSA",{"$f":"H19/H8","v":0.33821046707934721},"FSA",{"$f":"J19/J8","v":0.33764772087788408}]
[null,null,{"$f":"IF(C5>=667000,300150,C5*0.45)","v":300150},null,{"$f":"E8","v":1777000},{"$f":"F8/2","v":888500},null,{"$f":"H8-H15","v":601000},null,{"$f":"'Input Sheet'!B18","v":600000}]
[null,null,{"$f":"'Input Sheet'!B9","v":20},null,{"$f":"'Input Sheet'!B11","v":25},{"$f":"'Input Sheet'!B11","v":25},null,{"$f":"'Input Sheet'!B11","v":25},null,{"$f":"H20","v":25}]
[null,null,{"$f":"IF('Input Sheet'!B10-0.04>0.015,'Input Sheet'!B10-0.04,0.015)","v":1.4999999999999999E-2},null,{"$f":"'Input Sheet'!B10","v":0.04},{"$f":"IF('Input Sheet'!B10<=0.045,0.025,'Input Sheet'!B10-0.02)","v":2.5000000000000001E-2},null,{"$f":"IF(AND(I18>0.5,'Input Sheet'!B10>0.045),'Input Sheet'!B10,IF(AND(I18>0.5,'Input Sheet'!B10<=0.045),'Input Sheet'!B10,IF(AND(I18<=0.5,'Input Sheet'!B10<=0.045),0.025,IF(AND(I18<=0.5,'Input Sheet'!B10>0.045),'Input Sheet'!B10-0.02))))","v":2.5000000000000001E-2},null,{"$f":"IF(AND(K18>0.5,'Input Sheet'!B10>0.045),'Input Sheet'!B10,IF(AND(K18>0.5,'Input Sheet'!B10<=0.045),'Input Sheet'!B10,IF(AND(K18<=0.5,'Input Sheet'!B10<=0.045),0.025,IF(AND(K18<=0.5,'Input Sheet'!B10>0.045),'Input Sheet'!B10-0.02))))","v":2.5000000000000001E-2}]
["TOTAL PAYMENTS"]
[null,{"$f":"PMT(B17,B16,B15)*-1","v":127718.78301345142},{"$f":"PMT(C17,C16,C15)*-1+PMT(C21,C20,C19)*-1+PMT(C13,C12,C11)*-1","v":117242.54249760602},null,{"$f":"PMT(E21,E20,E19)*-1","v":113749.25787152983},{"$f":"PMT(F17,F16,F15)*-1+PMT(F21,F20,F19)*-1","v":112083.54735591245},null,{"$f":"PMT(H17,H16,H15)*-1+PMT(H21,H20,H19)*-1","v":117142.78230418757},null,{"$f":"PMT(J13,J12,J11)*-1+PMT(J17,J16,J15)*-1+PMT(J21,J20,J19)*-1","v":117160.37964313811}]
["COST/ACRE"]
[{"$f":"A5","v":1777000},"G-F0","BF/SDA     DP-FO",null,"D-FO","JOINT",null,"PART",null,"SHARED "]
["WILL BUY @"]
[{"$f":"'Input Sheet'!B13","v":8000},{"$f":"B23/A28","v":574.98607997051852},{"$f":"C23/A28","v":527.82236352326845},null,{"$f":"E23/A28","v":512.09570229163683},{"$f":"F23/A28","v":504.59672416842972},null,{"$f":"H23/A28","v":527.37324616404078},null,{"$f":"J23/A28","v":527.45246884924302}]
[{"$f":"A25/A27","v":222.125}]
[{"$f":"A27+200","v":8200},{"$f":"B23/A30","v":589.36073196978145},{"$f":"C23/A30","v":541.01792261135017},null,{"$f":"E23/A30","v":524.89809484892771},{"$f":"F23/A30","v":517.21164227264046},null,{"$f":"H23/A30","v":540.55757731814185},null,{"$f":"J23/A30","v":540.63878057047407}]
[{"$f":"A25/A29","v":216.70731707317074}]
[{"$f":"A27+400","v":8400},{"$f":"B23/A32","v":603.73538396904451},{"$f":"C23/A32","v":554.21348169943201},null,{"$f":"E23/A32","v":537.70048740621871},{"$f":"F23/A32","v":529.82656037685126},null,{"$f":"H23/A32","v":553.74190847224293},null,{"$f":"J23/A32","v":553.82509229170523}]
[{"$f":"A25/A31","v":211.54761904761904}]
[{"$f":"A27+600","v":8600},{"$f":"B23/A34","v":618.11003596830744},{"$f":"C23/A34","v":567.40904078751362},null,{"$f":"E23/A34","v":550.5028799635096},{"$f":"F23/A34","v":542.44147848106195},null,{"$f":"H23/A34","v":566.92623962634389},null,{"$f":"J23/A34","v":567.01140401293628}]
[{"$f":"A25/A33","v":206.62790697674419}]
[{"$f":"A27+800","v":8800},{"$f":"B23/A36","v":632.48468796757038},{"$f":"C23/A36","v":580.60459987559534},null,{"$f":"E23/A36","v":563.30527252080049},{"$f":"F23/A36","v":555.05639658527264},null,{"$f":"H23/A36","v":580.11057078044485},null,{"$f":"J23/A36","v":580.19771573416733}]
[{"$f":"A25/A35","v":201.93181818181819}]
[{"$f":"A27+1000","v":9000},{"$f":"B23/A38","v":646.85933996683332},{"$f":"C23/A38","v":593.80015896367706},null,{"$f":"E23/A38","v":576.10766507809137},{"$f":"F23/A38","v":567.67131468948344},null,{"$f":"H23/A38","v":593.29490193454592},null,{"$f":"J23/A38","v":593.38402745539838}]
[{"$f":"A25/A37","v":197.44444444444446}]
[{"$f":"A27+1200","v":9200},{"$f":"B23/A40","v":661.23399196609626},{"$f":"C23/A40","v":606.99571805175879},null,{"$f":"E23/A40","v":588.91005763538237},{"$f":"F23/A40","v":580.28623279369424},null,{"$f":"H23/A40","v":606.47923308864699},null,{"$f":"J23/A40","v":606.57033917662955}]
[{"$f":"A25/A39","v":193.15217391304347}]
[{"$f":"A27+1400","v":9400},{"$f":"B23/A42","v":675.60864396535919},{"$f":"C23/A42","v":620.19127713984051},null,{"$f":"E23/A42","v":601.71245019267326},{"$f":"F23/A42","v":592.90115089790493},null,{"$f":"H23/A42","v":619.66356424274795},null,{"$f":"J23/A42","v":619.7566508978606}]
[{"$f":"A25/A41","v":189.04255319148936}]
["Note:"]
["Loan limits for each program:  G-FO - $1,776,000; DDP-FO - $300,150; Joint - $1,200,000; D-FO - $600,000"]
["Total Combination G-FO & D-FO $1,776,000"]
[]
["The Downpayment program may receive up to a 95% guarantee.  Loan amount percentages are based on total purchase price."]
["The bank portion is automatically calculated when the loan limit is exceeded for the FSA and Bank Guaranteed portion. "]
["The interest rate for the bank portion is automatically used from Shared Lien Unguaranteed option. "]
[]
["Particpation Financing loan amount percentages are based on amount financed.  This dictates the interest rate on the FSA portion."]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}